﻿CREATE TABLE [dbo].[BillOrderPrescItem]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [PrescId] INT NOT NULL, 
    [ItemName] NVARCHAR(200) NOT NULL, 
    [ItemPrice] DECIMAL(18, 4) NOT NULL, 
    [Account] NVARCHAR(5) NOT NULL, 
    [Type] NVARCHAR(50) NOT NULL, 
    [Unit] NVARCHAR(50) NOT NULL, 
    [Money] DECIMAL(18, 4) NOT NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'处方ID',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = 'PrescId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = N'ItemName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'单价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = N'ItemPrice'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'数量',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = N'Account'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目费用类型:中药，材料，西药，治疗，化验',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = N'Type'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'单位',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = N'Unit'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目总价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderPrescItem',
    @level2type = N'COLUMN',
    @level2name = 'Money'